package com.example.qxfw.common.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.qxfw.common.entity.TravelPredict;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/************************************
*
* @author : HuangDeYin Jolly
* @since : JDK 11
* @Date : 2023/7/10  星期一   9:56
* @description : 此类用来
***************************************/
@Mapper
public interface TravelPredictMapperXml extends BaseMapper<TravelPredict> {
    /**
     * delete by primary key
     * @param jqname primaryKey
     * @return deleteCount
     */
    int deleteByPrimaryKey(@Param("jqname") String jqname, @Param("spotname") String spotname, @Param("type") String type);

    /**
     * insert record to table
     * @param record the record
     * @return insert count
     */
    int insert(TravelPredict record);

    /**
     * insert record to table selective
     * @param record the record
     * @return insert count
     */
    int insertSelective(TravelPredict record);

    /**
     * select by primary key
     * @param jqname primary key
     * @return object by primary key
     */
    TravelPredict selectByPrimaryKey(@Param("jqname") String jqname, @Param("spotname") String spotname, @Param("type") String type);

    /**
     * update record selective
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKeySelective(TravelPredict record);

    /**
     * update record
     * @param record the updated record
     * @return update count
     */
    int updateByPrimaryKey(TravelPredict record);

    List<TravelPredict> selectDistinctJqName();

    List<TravelPredict> selectDistinctSpotName();

    Integer clearTravelPredict();
}